{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 入门示例"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "█\r"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "Getting uuid of QR code.\n",
      "Downloading QR code.\n",
      "Please scan the QR code to log in.\n",
      "Please press confirm on your phone.\n",
      "Loading the contact, this may take a little while.\n",
      "Login successfully as 罗攀\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<ItchatReturnValue: {'BaseResponse': {'Ret': 0, 'ErrMsg': '请求成功', 'RawMsg': '请求成功'}, 'MsgID': '5738543168325686548', 'LocalID': '15466696311837'}>"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import itchat\n",
    "\n",
    "itchat.auto_login()\n",
    "\n",
    "itchat.send('好玩的itchat', toUserName='filehelper')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 获取好友信息"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<User: {'MemberList': <ContactList: []>, 'UserName': '@23092c76cbafa4bc97cfe9469515ee9e3f07fed23a555a83dd1205a1794a2311', 'City': '常德', 'DisplayName': '', 'PYQuanPin': 'luopan', 'RemarkPYInitial': '', 'Province': '湖南', 'KeyWord': '', 'RemarkName': '', 'PYInitial': 'LP', 'EncryChatRoomId': '', 'Alias': '', 'Signature': '', 'NickName': '罗攀', 'RemarkPYQuanPin': '', 'HeadImgUrl': '/cgi-bin/mmwebwx-bin/webwxgeticon?seq=470110&username=@23092c76cbafa4bc97cfe9469515ee9e3f07fed23a555a83dd1205a1794a2311&skey=@crypt_dcefb455_6a36eabc0dff5e0765c71c0f4592dea3', 'UniFriend': 0, 'Sex': 1, 'AppAccountFlag': 0, 'VerifyFlag': 0, 'ChatRoomId': 0, 'HideInputBarFlag': 0, 'AttrStatus': 233575, 'SnsFlag': 49, 'MemberCount': 0, 'OwnerUin': 0, 'ContactFlag': 1, 'Uin': 2185378081, 'StarFriend': 0, 'Statues': 0, 'WebWxPluginSwitch': 0, 'HeadImgFlag': 1, 'IsOwner': 0}>"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "friends = itchat.get_friends(update=True)\n",
    "friends[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import csv\n",
    "fp = open('friend.csv','w',newline='',encoding='utf-8')\n",
    "writer = csv.writer(fp)\n",
    "\n",
    "writer.writerow(['NickName','Sex','Province','City','Signature'])\n",
    "\n",
    "for friend in friends[1:]:\n",
    "    writer.writerow([friend['NickName'],friend['Sex'],friend['Province'],friend['City'],friend['Signature']])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 数据情况"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>NickName</th>\n",
       "      <th>Sex</th>\n",
       "      <th>Province</th>\n",
       "      <th>City</th>\n",
       "      <th>Signature</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>☀️</td>\n",
       "      <td>2</td>\n",
       "      <td>湖北</td>\n",
       "      <td>武汉</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>郭成</td>\n",
       "      <td>1</td>\n",
       "      <td>湖南</td>\n",
       "      <td>常德</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>彭彬</td>\n",
       "      <td>1</td>\n",
       "      <td>云南</td>\n",
       "      <td>昆明</td>\n",
       "      <td>啦啦啦</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>科莫呗比</td>\n",
       "      <td>1</td>\n",
       "      <td>湖南</td>\n",
       "      <td>常德</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Q</td>\n",
       "      <td>2</td>\n",
       "      <td>湖南</td>\n",
       "      <td>常德</td>\n",
       "      <td>如果再见不能红着脸   是否还能红着眼</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  NickName  Sex Province City            Signature\n",
       "0       ☀️    2       湖北   武汉                  NaN\n",
       "1       郭成    1       湖南   常德                  NaN\n",
       "2       彭彬    1       云南   昆明                  啦啦啦\n",
       "3     科莫呗比    1       湖南   常德                  NaN\n",
       "4        Q    2       湖南   常德  如果再见不能红着脸   是否还能红着眼"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = pd.read_csv('friend.csv',encoding='utf-8')\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 性别分析"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Sex\n",
       "0     21\n",
       "1    279\n",
       "2    169\n",
       "Name: Sex, dtype: int64"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sex = data.groupby('Sex')['Sex'].count()\n",
    "sex"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"a3092e03d4214c5eb045ff1b80689ba4\" style=\"width:900px;height:400px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts'], function(echarts) {\n",
       "        \n",
       "var myChart_a3092e03d4214c5eb045ff1b80689ba4 = echarts.init(document.getElementById('a3092e03d4214c5eb045ff1b80689ba4'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_a3092e03d4214c5eb045ff1b80689ba4 = {\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"text\": \"\\u5fae\\u4fe1\\u597d\\u53cb\\u6027\\u522b\\u5206\\u5e03\",\n",
       "            \"left\": \"auto\",\n",
       "            \"top\": \"auto\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 18\n",
       "            },\n",
       "            \"subtextStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"toolbox\": {\n",
       "        \"show\": true,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"left\": \"95%\",\n",
       "        \"top\": \"center\",\n",
       "        \"feature\": {\n",
       "            \"saveAsImage\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"save as image\"\n",
       "            },\n",
       "            \"restore\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"restore\"\n",
       "            },\n",
       "            \"dataView\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"data view\"\n",
       "            }\n",
       "        }\n",
       "    },\n",
       "    \"series_id\": 1699050,\n",
       "    \"tooltip\": {\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "        \"borderColor\": \"#333\",\n",
       "        \"borderWidth\": 0\n",
       "    },\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"pie\",\n",
       "            \"data\": [\n",
       "                {\n",
       "                    \"name\": \"\\u5916\\u661f\\u4eba\",\n",
       "                    \"value\": 21.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u7537\\u6027\",\n",
       "                    \"value\": 279.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5973\\u6027\",\n",
       "                    \"value\": 169.0\n",
       "                }\n",
       "            ],\n",
       "            \"radius\": [\n",
       "                \"30%\",\n",
       "                \"75%\"\n",
       "            ],\n",
       "            \"center\": [\n",
       "                \"50%\",\n",
       "                \"50%\"\n",
       "            ],\n",
       "            \"roseType\": \"radius\",\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"position\": \"outside\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"formatter\": \"{b}: {d}%\"\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    },\n",
       "                    \"formatter\": \"{b}: {d}%\"\n",
       "                }\n",
       "            },\n",
       "            \"seriesId\": 1699050\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"\\u5916\\u661f\\u4eba\",\n",
       "                \"\\u7537\\u6027\",\n",
       "                \"\\u5973\\u6027\"\n",
       "            ],\n",
       "            \"selectedMode\": \"multiple\",\n",
       "            \"show\": true,\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"top\",\n",
       "            \"orient\": \"horizontal\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"animation\": true,\n",
       "    \"color\": [\n",
       "        \"#b2d235\",\n",
       "        \"#f6f5ec\",\n",
       "        \"#726930\",\n",
       "        \"#918597\",\n",
       "        \"#444693\",\n",
       "        \"#fab27b\",\n",
       "        \"#6e7074\",\n",
       "        \"#2f4554\",\n",
       "        \"#546570\",\n",
       "        \"#1d953f\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f05b72\",\n",
       "        \"#2a5caa\",\n",
       "        \"#d48265\",\n",
       "        \"#ac6767\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#6950a1\",\n",
       "        \"#f47920\",\n",
       "        \"#bda29a\",\n",
       "        \"#6d8346\",\n",
       "        \"#c23531\",\n",
       "        \"#905a3d\",\n",
       "        \"#61a0a8\",\n",
       "        \"#ca8622\",\n",
       "        \"#749f83\"\n",
       "    ]\n",
       "};\n",
       "myChart_a3092e03d4214c5eb045ff1b80689ba4.setOption(option_a3092e03d4214c5eb045ff1b80689ba4);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ],
      "text/plain": [
       "<pyecharts.charts.pie.Pie at 0x202c3185d30>"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from pyecharts import Pie\n",
    "\n",
    "attr = ['外星人','男性','女性']\n",
    "\n",
    "v = list(sex)\n",
    "pie = Pie(\"微信好友性别分布\",  width=900)\n",
    "pie.add(\n",
    "    \"\",\n",
    "    attr,\n",
    "    v,\n",
    "    center=[50, 50],\n",
    "    is_random=True,\n",
    "    radius=[30, 75],\n",
    "    rosetype=\"radius\",\n",
    ")\n",
    "pie"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 好友地区分布"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>NickName</th>\n",
       "      <th>Sex</th>\n",
       "      <th>Province</th>\n",
       "      <th>City</th>\n",
       "      <th>Signature</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>☀️</td>\n",
       "      <td>2</td>\n",
       "      <td>湖北</td>\n",
       "      <td>武汉</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>郭成</td>\n",
       "      <td>1</td>\n",
       "      <td>湖南</td>\n",
       "      <td>常德</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>彭彬</td>\n",
       "      <td>1</td>\n",
       "      <td>云南</td>\n",
       "      <td>昆明</td>\n",
       "      <td>啦啦啦</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>科莫呗比</td>\n",
       "      <td>1</td>\n",
       "      <td>湖南</td>\n",
       "      <td>常德</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Q</td>\n",
       "      <td>2</td>\n",
       "      <td>湖南</td>\n",
       "      <td>常德</td>\n",
       "      <td>如果再见不能红着脸   是否还能红着眼</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  NickName  Sex Province City            Signature\n",
       "0       ☀️    2       湖北   武汉                  NaN\n",
       "1       郭成    1       湖南   常德                  NaN\n",
       "2       彭彬    1       云南   昆明                  啦啦啦\n",
       "3     科莫呗比    1       湖南   常德                  NaN\n",
       "4        Q    2       湖南   常德  如果再见不能红着脸   是否还能红着眼"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>NickName</th>\n",
       "      <th>Sex</th>\n",
       "      <th>Province</th>\n",
       "      <th>City</th>\n",
       "      <th>Signature</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>☀️</td>\n",
       "      <td>2</td>\n",
       "      <td>湖北</td>\n",
       "      <td>武汉</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>郭成</td>\n",
       "      <td>1</td>\n",
       "      <td>湖南</td>\n",
       "      <td>常德</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>彭彬</td>\n",
       "      <td>1</td>\n",
       "      <td>云南</td>\n",
       "      <td>昆明</td>\n",
       "      <td>啦啦啦</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>科莫呗比</td>\n",
       "      <td>1</td>\n",
       "      <td>湖南</td>\n",
       "      <td>常德</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Q</td>\n",
       "      <td>2</td>\n",
       "      <td>湖南</td>\n",
       "      <td>常德</td>\n",
       "      <td>如果再见不能红着脸   是否还能红着眼</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>夏夜星空</td>\n",
       "      <td>2</td>\n",
       "      <td>湖南</td>\n",
       "      <td>常德</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>此号停用</td>\n",
       "      <td>2</td>\n",
       "      <td>湖南</td>\n",
       "      <td>常德</td>\n",
       "      <td>做自己让以后的自己感谢的事！</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>夏</td>\n",
       "      <td>1</td>\n",
       "      <td>Abu Dhabi</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>宋鹏</td>\n",
       "      <td>1</td>\n",
       "      <td>湖南</td>\n",
       "      <td>长沙</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>木头琪</td>\n",
       "      <td>2</td>\n",
       "      <td>湖南</td>\n",
       "      <td>长沙</td>\n",
       "      <td>青春荒唐，不负自己。</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>龙望葵</td>\n",
       "      <td>2</td>\n",
       "      <td>湖南</td>\n",
       "      <td>常德</td>\n",
       "      <td>……</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>付鑫景</td>\n",
       "      <td>2</td>\n",
       "      <td>湖南</td>\n",
       "      <td>长沙</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>黄逸炀</td>\n",
       "      <td>1</td>\n",
       "      <td>浙江</td>\n",
       "      <td>温州</td>\n",
       "      <td>觉得苦那就吃一颗糖</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>王品</td>\n",
       "      <td>1</td>\n",
       "      <td>湖南</td>\n",
       "      <td>长沙</td>\n",
       "      <td>幸福与感恩同行……</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>瑀小刘</td>\n",
       "      <td>2</td>\n",
       "      <td>北京</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>睡袋</td>\n",
       "      <td>2</td>\n",
       "      <td>江苏</td>\n",
       "      <td>苏州</td>\n",
       "      <td>人意烂漫，只向桃花开二分。</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>向往</td>\n",
       "      <td>1</td>\n",
       "      <td>广东</td>\n",
       "      <td>清远</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>刘卓</td>\n",
       "      <td>1</td>\n",
       "      <td>湖南</td>\n",
       "      <td>长沙</td>\n",
       "      <td>心累……</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>长天</td>\n",
       "      <td>1</td>\n",
       "      <td>湖南</td>\n",
       "      <td>长沙</td>\n",
       "      <td>夫学者载籍极博，尤考信于六艺。</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>羊锅</td>\n",
       "      <td>1</td>\n",
       "      <td>湖南</td>\n",
       "      <td>邵阳</td>\n",
       "      <td>(￣ε(#￣)☆╰╮(ಥ_ಥ)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>赵乙颖 🏃 🕖</td>\n",
       "      <td>2</td>\n",
       "      <td>湖南</td>\n",
       "      <td>长沙</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>宝毓</td>\n",
       "      <td>1</td>\n",
       "      <td>广东</td>\n",
       "      <td>深圳</td>\n",
       "      <td>让优秀成为一种习惯！</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>林立彬</td>\n",
       "      <td>1</td>\n",
       "      <td>广东</td>\n",
       "      <td>清远</td>\n",
       "      <td>听得见叶儿声声降</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>awed</td>\n",
       "      <td>1</td>\n",
       "      <td>浙江</td>\n",
       "      <td>嘉兴</td>\n",
       "      <td>我觉得人生就是要经历，我需要一段独属于我自己的时光。</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Mr.Robot</td>\n",
       "      <td>1</td>\n",
       "      <td>吉林</td>\n",
       "      <td>长春</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>天涯</td>\n",
       "      <td>1</td>\n",
       "      <td>湖南</td>\n",
       "      <td>长沙</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>王</td>\n",
       "      <td>1</td>\n",
       "      <td>山东</td>\n",
       "      <td>济南</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>bookbook</td>\n",
       "      <td>2</td>\n",
       "      <td>北京</td>\n",
       "      <td>朝阳</td>\n",
       "      <td>没有意义，要寻找意义</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>丁丁_</td>\n",
       "      <td>1</td>\n",
       "      <td>湖南</td>\n",
       "      <td>长沙</td>\n",
       "      <td>一身诗意千寻瀑，万古人间四月天。最是人间留不住朱颜辞镜花辞树</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>starmorning</td>\n",
       "      <td>1</td>\n",
       "      <td>上海</td>\n",
       "      <td>徐汇</td>\n",
       "      <td>Mind reform!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>433</th>\n",
       "      <td>Cxy</td>\n",
       "      <td>1</td>\n",
       "      <td>山东</td>\n",
       "      <td>聊城</td>\n",
       "      <td>实干兴邦</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>434</th>\n",
       "      <td>铁皮羊</td>\n",
       "      <td>1</td>\n",
       "      <td>江苏</td>\n",
       "      <td>苏州</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>435</th>\n",
       "      <td>😊开心</td>\n",
       "      <td>2</td>\n",
       "      <td>湖南</td>\n",
       "      <td>长沙</td>\n",
       "      <td>你要变得强大，才能保护好自己和你爱的人</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>436</th>\n",
       "      <td>『夜＆弦月』</td>\n",
       "      <td>2</td>\n",
       "      <td>河北</td>\n",
       "      <td>承德</td>\n",
       "      <td>君且随意</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>437</th>\n",
       "      <td>李十六</td>\n",
       "      <td>1</td>\n",
       "      <td>湖南</td>\n",
       "      <td>长沙</td>\n",
       "      <td>滚蛋吧，2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>438</th>\n",
       "      <td>吃瓜群众</td>\n",
       "      <td>1</td>\n",
       "      <td>湖南</td>\n",
       "      <td>长沙</td>\n",
       "      <td>18390219162</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>440</th>\n",
       "      <td>木</td>\n",
       "      <td>2</td>\n",
       "      <td>Lyon</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>441</th>\n",
       "      <td>ling</td>\n",
       "      <td>2</td>\n",
       "      <td>广东</td>\n",
       "      <td>广州</td>\n",
       "      <td>one by one,  step by step. (每天进步一丢丢！&lt;span clas...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>442</th>\n",
       "      <td>@,@</td>\n",
       "      <td>1</td>\n",
       "      <td>海南</td>\n",
       "      <td>儋州</td>\n",
       "      <td>那些曾让你哭的事，总有一天你会笑着说出来……</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>444</th>\n",
       "      <td>H&amp;amp;Y</td>\n",
       "      <td>1</td>\n",
       "      <td>江苏</td>\n",
       "      <td>淮安</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>445</th>\n",
       "      <td>胡振南</td>\n",
       "      <td>1</td>\n",
       "      <td>湖南</td>\n",
       "      <td>长沙</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>446</th>\n",
       "      <td>双马尾િ😄ી元气7777</td>\n",
       "      <td>2</td>\n",
       "      <td>江苏</td>\n",
       "      <td>南京</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>448</th>\n",
       "      <td>海风</td>\n",
       "      <td>1</td>\n",
       "      <td>广东</td>\n",
       "      <td>深圳</td>\n",
       "      <td>关注过程，享受生活\\n上半场专注事业，下半场回归家庭</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>450</th>\n",
       "      <td>千百度</td>\n",
       "      <td>1</td>\n",
       "      <td>上海</td>\n",
       "      <td>浦东新区</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>451</th>\n",
       "      <td>Love.YY</td>\n",
       "      <td>2</td>\n",
       "      <td>上海</td>\n",
       "      <td>闸北</td>\n",
       "      <td>But you didn't.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>452</th>\n",
       "      <td>super胖胖祥</td>\n",
       "      <td>1</td>\n",
       "      <td>浙江</td>\n",
       "      <td>杭州</td>\n",
       "      <td>做事之道，唯敬唯勤，持之以恒。to be a better me。</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>454</th>\n",
       "      <td>natule</td>\n",
       "      <td>1</td>\n",
       "      <td>湖南</td>\n",
       "      <td>长沙</td>\n",
       "      <td>生活很苦  学会快乐</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>455</th>\n",
       "      <td>jlzoa</td>\n",
       "      <td>2</td>\n",
       "      <td>广东</td>\n",
       "      <td>深圳</td>\n",
       "      <td>要瘦要有钱</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>456</th>\n",
       "      <td>等枝</td>\n",
       "      <td>1</td>\n",
       "      <td>河南</td>\n",
       "      <td>信阳</td>\n",
       "      <td>A laity𓃟</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>457</th>\n",
       "      <td>刘阿敏</td>\n",
       "      <td>2</td>\n",
       "      <td>河南</td>\n",
       "      <td>信阳</td>\n",
       "      <td>女孩子一定要努力，想要的东西都很贵，想去的地方都很远&lt;span class=\"emoji e...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>458</th>\n",
       "      <td>Leopard</td>\n",
       "      <td>1</td>\n",
       "      <td>山西</td>\n",
       "      <td>太原</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>459</th>\n",
       "      <td>Ivan</td>\n",
       "      <td>2</td>\n",
       "      <td>湖南</td>\n",
       "      <td>长沙</td>\n",
       "      <td>怦然心动！</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>461</th>\n",
       "      <td>醉时光</td>\n",
       "      <td>1</td>\n",
       "      <td>河南</td>\n",
       "      <td>安阳</td>\n",
       "      <td>人在得意时须沉得住傲气；失意时要忍得住火气</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>462</th>\n",
       "      <td>吱~夏</td>\n",
       "      <td>2</td>\n",
       "      <td>湖南</td>\n",
       "      <td>怀化</td>\n",
       "      <td>会笑的酒窝，会流泪的眼睛</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>463</th>\n",
       "      <td>AAaa安乡德牌童装</td>\n",
       "      <td>2</td>\n",
       "      <td>湖南</td>\n",
       "      <td>常德</td>\n",
       "      <td>陪你长大👪</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>464</th>\n",
       "      <td>X.Q</td>\n",
       "      <td>2</td>\n",
       "      <td>湖南</td>\n",
       "      <td>常德</td>\n",
       "      <td>所有的经历都是成长</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>465</th>\n",
       "      <td>黎奕晖๑~</td>\n",
       "      <td>2</td>\n",
       "      <td>湖南</td>\n",
       "      <td>长沙</td>\n",
       "      <td>不骄不躁，未来可期～2019请多多指教🍭</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>466</th>\n",
       "      <td>👑 何羽原</td>\n",
       "      <td>2</td>\n",
       "      <td>湖南</td>\n",
       "      <td>长沙</td>\n",
       "      <td>不要低头 &lt;span class=\"emoji emoji1f451\"&gt;&lt;/span&gt; 会掉</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>467</th>\n",
       "      <td>doxi Diiee</td>\n",
       "      <td>2</td>\n",
       "      <td>浙江</td>\n",
       "      <td>宁波</td>\n",
       "      <td>今天的一切就算突然我也不奇怪</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468</th>\n",
       "      <td>SWAITML</td>\n",
       "      <td>1</td>\n",
       "      <td>山东</td>\n",
       "      <td>潍坊</td>\n",
       "      <td>非常努力，才会毫不费力。。。</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>381 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         NickName  Sex   Province  City  \\\n",
       "0              ☀️    2         湖北    武汉   \n",
       "1              郭成    1         湖南    常德   \n",
       "2              彭彬    1         云南    昆明   \n",
       "3            科莫呗比    1         湖南    常德   \n",
       "4               Q    2         湖南    常德   \n",
       "8            夏夜星空    2         湖南    常德   \n",
       "9            此号停用    2         湖南    常德   \n",
       "10              夏    1  Abu Dhabi   NaN   \n",
       "12             宋鹏    1         湖南    长沙   \n",
       "14            木头琪    2         湖南    长沙   \n",
       "15            龙望葵    2         湖南    常德   \n",
       "16            付鑫景    2         湖南    长沙   \n",
       "18            黄逸炀    1         浙江    温州   \n",
       "19             王品    1         湖南    长沙   \n",
       "20            瑀小刘    2         北京   NaN   \n",
       "21             睡袋    2         江苏    苏州   \n",
       "22             向往    1         广东    清远   \n",
       "23             刘卓    1         湖南    长沙   \n",
       "24             长天    1         湖南    长沙   \n",
       "25             羊锅    1         湖南    邵阳   \n",
       "26        赵乙颖 🏃 🕖    2         湖南    长沙   \n",
       "27             宝毓    1         广东    深圳   \n",
       "28            林立彬    1         广东    清远   \n",
       "29           awed    1         浙江    嘉兴   \n",
       "30       Mr.Robot    1         吉林    长春   \n",
       "31             天涯    1         湖南    长沙   \n",
       "32              王    1         山东    济南   \n",
       "33       bookbook    2         北京    朝阳   \n",
       "34            丁丁_    1         湖南    长沙   \n",
       "35    starmorning    1         上海    徐汇   \n",
       "..            ...  ...        ...   ...   \n",
       "433           Cxy    1         山东    聊城   \n",
       "434           铁皮羊    1         江苏    苏州   \n",
       "435           😊开心    2         湖南    长沙   \n",
       "436        『夜＆弦月』    2         河北    承德   \n",
       "437           李十六    1         湖南    长沙   \n",
       "438          吃瓜群众    1         湖南    长沙   \n",
       "440             木    2       Lyon   NaN   \n",
       "441          ling    2         广东    广州   \n",
       "442           @,@    1         海南    儋州   \n",
       "444       H&amp;Y    1         江苏    淮安   \n",
       "445           胡振南    1         湖南    长沙   \n",
       "446  双马尾િ😄ી元气7777    2         江苏    南京   \n",
       "448            海风    1         广东    深圳   \n",
       "450           千百度    1         上海  浦东新区   \n",
       "451       Love.YY    2         上海    闸北   \n",
       "452      super胖胖祥    1         浙江    杭州   \n",
       "454        natule    1         湖南    长沙   \n",
       "455         jlzoa    2         广东    深圳   \n",
       "456            等枝    1         河南    信阳   \n",
       "457           刘阿敏    2         河南    信阳   \n",
       "458       Leopard    1         山西    太原   \n",
       "459          Ivan    2         湖南    长沙   \n",
       "461           醉时光    1         河南    安阳   \n",
       "462           吱~夏    2         湖南    怀化   \n",
       "463    AAaa安乡德牌童装    2         湖南    常德   \n",
       "464           X.Q    2         湖南    常德   \n",
       "465         黎奕晖๑~    2         湖南    长沙   \n",
       "466         👑 何羽原    2         湖南    长沙   \n",
       "467    doxi Diiee    2         浙江    宁波   \n",
       "468       SWAITML    1         山东    潍坊   \n",
       "\n",
       "                                             Signature  \n",
       "0                                                  NaN  \n",
       "1                                                  NaN  \n",
       "2                                                  啦啦啦  \n",
       "3                                                  NaN  \n",
       "4                                  如果再见不能红着脸   是否还能红着眼  \n",
       "8                                                  NaN  \n",
       "9                                       做自己让以后的自己感谢的事！  \n",
       "10                                                 NaN  \n",
       "12                                                 NaN  \n",
       "14                                          青春荒唐，不负自己。  \n",
       "15                                                  ……  \n",
       "16                                                 NaN  \n",
       "18                                           觉得苦那就吃一颗糖  \n",
       "19                                           幸福与感恩同行……  \n",
       "20                                                 NaN  \n",
       "21                                       人意烂漫，只向桃花开二分。  \n",
       "22                                                 NaN  \n",
       "23                                                心累……  \n",
       "24                                     夫学者载籍极博，尤考信于六艺。  \n",
       "25                                     (￣ε(#￣)☆╰╮(ಥ_ಥ)  \n",
       "26                                                 NaN  \n",
       "27                                          让优秀成为一种习惯！  \n",
       "28                                            听得见叶儿声声降  \n",
       "29                          我觉得人生就是要经历，我需要一段独属于我自己的时光。  \n",
       "30                                                 NaN  \n",
       "31                                                 NaN  \n",
       "32                                                 NaN  \n",
       "33                                          没有意义，要寻找意义  \n",
       "34                      一身诗意千寻瀑，万古人间四月天。最是人间留不住朱颜辞镜花辞树  \n",
       "35                                        Mind reform!  \n",
       "..                                                 ...  \n",
       "433                                               实干兴邦  \n",
       "434                                                NaN  \n",
       "435                                你要变得强大，才能保护好自己和你爱的人  \n",
       "436                                               君且随意  \n",
       "437                                           滚蛋吧，2018  \n",
       "438                                        18390219162  \n",
       "440                                                NaN  \n",
       "441  one by one,  step by step. (每天进步一丢丢！<span clas...  \n",
       "442                             那些曾让你哭的事，总有一天你会笑着说出来……  \n",
       "444                                                NaN  \n",
       "445                                                NaN  \n",
       "446                                                NaN  \n",
       "448                         关注过程，享受生活\\n上半场专注事业，下半场回归家庭  \n",
       "450                                                NaN  \n",
       "451                                    But you didn't.  \n",
       "452                  做事之道，唯敬唯勤，持之以恒。to be a better me。  \n",
       "454                                         生活很苦  学会快乐  \n",
       "455                                              要瘦要有钱  \n",
       "456                                           A laity𓃟  \n",
       "457  女孩子一定要努力，想要的东西都很贵，想去的地方都很远<span class=\"emoji e...  \n",
       "458                                                NaN  \n",
       "459                                              怦然心动！  \n",
       "461                              人在得意时须沉得住傲气；失意时要忍得住火气  \n",
       "462                                       会笑的酒窝，会流泪的眼睛  \n",
       "463                                              陪你长大👪  \n",
       "464                                          所有的经历都是成长  \n",
       "465                               不骄不躁，未来可期～2019请多多指教🍭  \n",
       "466     不要低头 <span class=\"emoji emoji1f451\"></span> 会掉  \n",
       "467                                     今天的一切就算突然我也不奇怪  \n",
       "468                                     非常努力，才会毫不费力。。。  \n",
       "\n",
       "[381 rows x 5 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_data1 = data[data['Province'].notnull()]\n",
    "new_data1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Province\n",
       "Abu Dhabi       1\n",
       "Arles           1\n",
       "Bali            1\n",
       "Berlin          1\n",
       "California      1\n",
       "Chiang Mai      1\n",
       "Clare           2\n",
       "Dublin          1\n",
       "Galway          1\n",
       "Luanda          1\n",
       "Lyon            1\n",
       "New York        1\n",
       "Paris           3\n",
       "Queensland      1\n",
       "Scotland        1\n",
       "Seoul           1\n",
       "Wicklow         1\n",
       "上海             23\n",
       "云南              2\n",
       "内蒙古             3\n",
       "北京             36\n",
       "吉林              2\n",
       "四川              3\n",
       "天津              4\n",
       "安徽              3\n",
       "山东              9\n",
       "山西              2\n",
       "广东             41\n",
       "广西              3\n",
       "新疆              2\n",
       "江苏             26\n",
       "江西              2\n",
       "河北              2\n",
       "河南             38\n",
       "浙江             12\n",
       "海南              2\n",
       "湖北             13\n",
       "湖南            111\n",
       "甘肃              2\n",
       "福建              2\n",
       "西藏              1\n",
       "辽宁              3\n",
       "重庆              5\n",
       "陕西              5\n",
       "青海              1\n",
       "黑龙江             3\n",
       "Name: Province, dtype: int64"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "province = data.groupby('Province')['Province'].count()\n",
    "province"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min', 'china': '/nbextensions/echarts-countries-js/china'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"4b266302b3164b90ad8fbf9808b4ad69\" style=\"width:1200px;height:600px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts', 'china'], function(echarts) {\n",
       "        \n",
       "var myChart_4b266302b3164b90ad8fbf9808b4ad69 = echarts.init(document.getElementById('4b266302b3164b90ad8fbf9808b4ad69'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_4b266302b3164b90ad8fbf9808b4ad69 = {\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"text\": \"\\u597d\\u53cb\\u5730\\u533a\\u5206\\u5e03\",\n",
       "            \"left\": \"auto\",\n",
       "            \"top\": \"auto\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 18\n",
       "            },\n",
       "            \"subtextStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"toolbox\": {\n",
       "        \"show\": true,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"left\": \"95%\",\n",
       "        \"top\": \"center\",\n",
       "        \"feature\": {\n",
       "            \"saveAsImage\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"save as image\"\n",
       "            },\n",
       "            \"restore\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"restore\"\n",
       "            },\n",
       "            \"dataView\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"data view\"\n",
       "            }\n",
       "        }\n",
       "    },\n",
       "    \"series_id\": 5620741,\n",
       "    \"tooltip\": {\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "        \"borderColor\": \"#333\",\n",
       "        \"borderWidth\": 0\n",
       "    },\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"map\",\n",
       "            \"symbol\": \"circle\",\n",
       "            \"label\": {\n",
       "                \"normal\": {\n",
       "                    \"show\": false,\n",
       "                    \"position\": \"top\",\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                },\n",
       "                \"emphasis\": {\n",
       "                    \"show\": true,\n",
       "                    \"textStyle\": {\n",
       "                        \"fontSize\": 12\n",
       "                    }\n",
       "                }\n",
       "            },\n",
       "            \"mapType\": \"china\",\n",
       "            \"data\": [\n",
       "                {\n",
       "                    \"name\": \"Abu Dhabi\",\n",
       "                    \"value\": 1.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"Arles\",\n",
       "                    \"value\": 1.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"Bali\",\n",
       "                    \"value\": 1.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"Berlin\",\n",
       "                    \"value\": 1.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"California\",\n",
       "                    \"value\": 1.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"Chiang Mai\",\n",
       "                    \"value\": 1.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"Clare\",\n",
       "                    \"value\": 2.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"Dublin\",\n",
       "                    \"value\": 1.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"Galway\",\n",
       "                    \"value\": 1.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"Luanda\",\n",
       "                    \"value\": 1.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"Lyon\",\n",
       "                    \"value\": 1.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"New York\",\n",
       "                    \"value\": 1.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"Paris\",\n",
       "                    \"value\": 3.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"Queensland\",\n",
       "                    \"value\": 1.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"Scotland\",\n",
       "                    \"value\": 1.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"Seoul\",\n",
       "                    \"value\": 1.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"Wicklow\",\n",
       "                    \"value\": 1.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u4e0a\\u6d77\",\n",
       "                    \"value\": 23.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u4e91\\u5357\",\n",
       "                    \"value\": 2.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5185\\u8499\\u53e4\",\n",
       "                    \"value\": 3.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5317\\u4eac\",\n",
       "                    \"value\": 36.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5409\\u6797\",\n",
       "                    \"value\": 2.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u56db\\u5ddd\",\n",
       "                    \"value\": 3.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5929\\u6d25\",\n",
       "                    \"value\": 4.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5b89\\u5fbd\",\n",
       "                    \"value\": 3.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5c71\\u4e1c\",\n",
       "                    \"value\": 9.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5c71\\u897f\",\n",
       "                    \"value\": 2.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u4e1c\",\n",
       "                    \"value\": 41.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e7f\\u897f\",\n",
       "                    \"value\": 3.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u65b0\\u7586\",\n",
       "                    \"value\": 2.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u6c5f\\u82cf\",\n",
       "                    \"value\": 26.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u6c5f\\u897f\",\n",
       "                    \"value\": 2.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u6cb3\\u5317\",\n",
       "                    \"value\": 2.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u6cb3\\u5357\",\n",
       "                    \"value\": 38.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u6d59\\u6c5f\",\n",
       "                    \"value\": 12.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u6d77\\u5357\",\n",
       "                    \"value\": 2.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u6e56\\u5317\",\n",
       "                    \"value\": 13.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u6e56\\u5357\",\n",
       "                    \"value\": 111.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u7518\\u8083\",\n",
       "                    \"value\": 2.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u798f\\u5efa\",\n",
       "                    \"value\": 2.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u897f\\u85cf\",\n",
       "                    \"value\": 1.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u8fbd\\u5b81\",\n",
       "                    \"value\": 3.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u91cd\\u5e86\",\n",
       "                    \"value\": 5.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u9655\\u897f\",\n",
       "                    \"value\": 5.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u9752\\u6d77\",\n",
       "                    \"value\": 1.0\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u9ed1\\u9f99\\u6c5f\",\n",
       "                    \"value\": 3.0\n",
       "                }\n",
       "            ],\n",
       "            \"roam\": true,\n",
       "            \"showLegendSymbol\": true\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [\n",
       "                \"\"\n",
       "            ],\n",
       "            \"selectedMode\": \"multiple\",\n",
       "            \"show\": true,\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"top\",\n",
       "            \"orient\": \"horizontal\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"animation\": true,\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\",\n",
       "        \"#f6f5ec\"\n",
       "    ],\n",
       "    \"visualMap\": {\n",
       "        \"type\": \"continuous\",\n",
       "        \"min\": 0,\n",
       "        \"max\": 100,\n",
       "        \"text\": [\n",
       "            \"high\",\n",
       "            \"low\"\n",
       "        ],\n",
       "        \"textStyle\": {\n",
       "            \"color\": \"#000\"\n",
       "        },\n",
       "        \"inRange\": {\n",
       "            \"color\": [\n",
       "                \"#50a3ba\",\n",
       "                \"#eac763\",\n",
       "                \"#d94e5d\"\n",
       "            ]\n",
       "        },\n",
       "        \"calculable\": true,\n",
       "        \"splitNumber\": 5,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"left\": \"left\",\n",
       "        \"top\": \"bottom\",\n",
       "        \"showLabel\": true\n",
       "    }\n",
       "};\n",
       "myChart_4b266302b3164b90ad8fbf9808b4ad69.setOption(option_4b266302b3164b90ad8fbf9808b4ad69);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ],
      "text/plain": [
       "<pyecharts.charts.map.Map at 0x202c34d3898>"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from pyecharts import Map\n",
    "\n",
    "value = list(province)\n",
    "attr = list(province.index)\n",
    "map = Map(\"好友地区分布\", width=1200, height=600)\n",
    "map.add(\n",
    "    \"\",\n",
    "    attr,\n",
    "    value,\n",
    "    maptype=\"china\",\n",
    "    is_visualmap=True,\n",
    "    visual_text_color=\"#000\",\n",
    ")\n",
    "map"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 个性签名词云图"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>NickName</th>\n",
       "      <th>Sex</th>\n",
       "      <th>Province</th>\n",
       "      <th>City</th>\n",
       "      <th>Signature</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>☀️</td>\n",
       "      <td>2</td>\n",
       "      <td>湖北</td>\n",
       "      <td>武汉</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>郭成</td>\n",
       "      <td>1</td>\n",
       "      <td>湖南</td>\n",
       "      <td>常德</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>彭彬</td>\n",
       "      <td>1</td>\n",
       "      <td>云南</td>\n",
       "      <td>昆明</td>\n",
       "      <td>啦啦啦</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>科莫呗比</td>\n",
       "      <td>1</td>\n",
       "      <td>湖南</td>\n",
       "      <td>常德</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Q</td>\n",
       "      <td>2</td>\n",
       "      <td>湖南</td>\n",
       "      <td>常德</td>\n",
       "      <td>如果再见不能红着脸   是否还能红着眼</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  NickName  Sex Province City            Signature\n",
       "0       ☀️    2       湖北   武汉                  NaN\n",
       "1       郭成    1       湖南   常德                  NaN\n",
       "2       彭彬    1       云南   昆明                  啦啦啦\n",
       "3     科莫呗比    1       湖南   常德                  NaN\n",
       "4        Q    2       湖南   常德  如果再见不能红着脸   是否还能红着眼"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>NickName</th>\n",
       "      <th>Sex</th>\n",
       "      <th>Province</th>\n",
       "      <th>City</th>\n",
       "      <th>Signature</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>彭彬</td>\n",
       "      <td>1</td>\n",
       "      <td>云南</td>\n",
       "      <td>昆明</td>\n",
       "      <td>啦啦啦</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Q</td>\n",
       "      <td>2</td>\n",
       "      <td>湖南</td>\n",
       "      <td>常德</td>\n",
       "      <td>如果再见不能红着脸   是否还能红着眼</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>一袭水袖舞倾城</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>谁的青春不迷茫</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>此号停用</td>\n",
       "      <td>2</td>\n",
       "      <td>湖南</td>\n",
       "      <td>常德</td>\n",
       "      <td>做自己让以后的自己感谢的事！</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>l-半</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>推荐3个好友减5元，推荐5个好友减10元。新顾客9折，老顾客85折。</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   NickName  Sex Province City                           Signature\n",
       "2        彭彬    1       云南   昆明                                 啦啦啦\n",
       "4         Q    2       湖南   常德                 如果再见不能红着脸   是否还能红着眼\n",
       "7   一袭水袖舞倾城    2      NaN  NaN                             谁的青春不迷茫\n",
       "9      此号停用    2       湖南   常德                      做自己让以后的自己感谢的事！\n",
       "13      l-半    0      NaN  NaN  推荐3个好友减5元，推荐5个好友减10元。新顾客9折，老顾客85折。"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_data2 = data[data['Signature'].notnull()]\n",
    "new_data2.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'啦啦啦如果再见不能红着脸   是否还能红着眼谁的青春不迷茫做自己让以后的自己感谢的事！推荐3个好友减5元，推荐5个好友减10元。新顾客9折，老顾客85折。青春荒唐，不负自己。  ……觉得苦那就吃一颗糖幸福与感恩同行……人意烂漫，只向桃花开二分。心累……夫学者载籍极博，尤考信于六艺。(￣ε(#￣)☆╰╮(ಥ_ಥ)让优秀成为一种习惯！听得见叶儿声声降我觉得人生就是要经历，我需要一段独属于我自己的时光。没有意义，要寻找意义一身诗意千寻瀑，万古人间四月天。最是人间留不住朱颜辞镜花辞树Mind reform!正向，有爱，幸福的传承。静下心来才能看清自己！。理解力争执无论怎样，开心最重要~\\\\(≧▽≦)/~i am a MAN刻意练习，改变变好。天天忙！用扯淡的态度，面对操蛋的人生。海南航空直飞<span class=\"emoji emoji2708\"></span>️薇薇安千层水果蛋糕<span class=\"emoji emoji1f370\"></span>，每周二四六甜蜜到货一念放下万般自在.有事打电话，15922604772DO IT, DO IT RIGHT, DO IT RIGHT NOW!hiLIVING FOR YOURSELF新的征程童心不泯我选择，我喜欢！你就是我想要的未来。图书出版——电子工业出版社博文视点啦啦啦make it happenYou make my heart smile.回忆曾经的青葱岁月是现在最大的财富！！！6225684139000063236师者，所以传道！授业，解惑也！大步向前～我爱大自然，其次是艺术坦坦荡荡Life  is  so...溯雪十年孤半影，笔锋三尺半江湖。生如夏花热爱生活！浅醉中年，唯心独醉。人生似茶，苦也似茶，香亦似茶。努力并不是为了感动谁，也并不是做给谁看！简单的生活简单的过铁华姐不思进取浅醉中年，唯心独醉。人生似茶，苦也似茶，香亦似茶。体到、悟道、得到γνῶθι σεαυτόν   μηδὲν ἄγαν专注精准流量，营销思维策划，暴利项目挖掘，欢迎同频朋友交流。 小知不可使谋事，小忠不可使主法。发现自己不求与人相比，但求无愧于自己每日精进唤醒绮梦憎啼鸟，罥入情丝奈网虫。\\n只要心中有喝啥都是酒我们总是习惯了过去，而来不及适应现在。林业相信，确信，坚信。世事无常，珍重眼前只有经受住狂风暴雨的洗礼，才能练就波澜不惊的淡定！！人生常有遗憾，幸好文字能温情温伤。Don\\'t stay whrere you are.彩石滴酒未进人已醉，热泪方流心已碎。淡忘哀愁苦与累，今朝有酒今朝<span class=\"emoji emoji1f63a\"></span>扬帆，启航！！！不会游泳的程序媛不是好司机所有的为时晚矣都是恰逢其时滴水穿石非一日之寒，君临天下非一日之功。见自己，见天地，见众生为了进步 别怕犯错‼️学习使我快乐🌚我是个杀手，我莫得感情，也莫得钱你好我就好我们真正怕的是我们光明的一面，不是我们阴暗的一面。智者一切求自己，愚者一切求他人如果不能停留下来，那么始终都是过客。未填写有朝一日权倾在手，便杀尽天下负我之人一群狼在草原上可以无敌，一匹狼在月光下依旧可以嚎叫！\\u3000生活，就像骑单车。要保持平衡，就得不断往前走。叽里呱啦咻<span class=\"emoji emoji1f431\"></span>~杉木、水杉、柳杉、落羽杉Ultimate论，何以为人识人间烟火一个在当地较为“英俊”的人(*¯︶¯*)包子包子包子 体质棒棒我是一只小鸭子，咿呀咿呀游注销自古深情留不住，总是套路得人心。美颜像鸡，不美颜像猪…RuY1今天没约到科三考试的，明早9点前继续约麓谷考场不逼自己一把.不知道自己<span class=\"emoji emoji1f236\"></span>️多优秀做一只美美的小熊<span class=\"emoji emoji1f43b\"></span>+86-15574309401越努力越幸运温和从容，岁月静好Yearn soulmate直面恐惧，才能战胜恐惧\\n三年河西三年河东，莫欺少年穷管不了那么多于内，选择一条自己成长的路，荆棘密布，我也得走。微笑面对每一天go go go行业交流永远相信美好的事情即将发生认真对待生活，生活才会认真对你世界这么大，那么美，我要到处看看。不会游泳的程序媛不是好司机Best  wishes for you <span class=\"emoji emoji2764\"></span>谁不是平凡且伟大着人生充满着期待，梦想连接着未来你不能把这个世界让给你所鄙视的人…一无所有正好，可以放手一博敬畏之心当你一无所有的时候，就真的可以为所欲为了努力才能拥有梦想的实现sometimes,nowhere means now here出来抢劫也要本性the crownless will be kingThere’s such a lot of world to see.用你喜欢的方式探索世界我喜欢一切美的东西和善良的人。<span class=\"emoji emoji2764\"></span>️听闻遇见，一次就好SinanTang.github.io就是现在。微信公众号:老居杂货铺(Juustore)，欢迎进店收保护费唯一，非之一人生如逆旅 我亦是行人自从得了神经病，整个人可精神多了糖宝，希望你健康快乐的长大挫折总是如期而至，惊喜总是不期而遇大道至简  坚持者寡万物皆有裂痕，那是光照进来的地方宽于慈善，不忤于物。Msjjsjse年轻就该拼命！否则就是浪费光阴！淳德全道，和于阴阳，调于四时，去世离俗，积精全神……Godlovezt~往后的余生，我只要你。18874286389抓紧时间追赶在你之上的那些人！我能否变成淤泥，再一次沾染你见天地，见众生，见自己，足以见世面富在术数，不在劳身；利在势居，不在力耕。「正青春，去探索」fasker＆健哥的迷妹！！与城市数据团一起学习数据分析～(\\xa0*・ω・)✄为精彩生活而活着 -- L XLYouth is not a time of life; it is a state of mind.好好生活付费知识的搬运工sunset lover虽有多闻，若不修行，与不闻等。如人说食，终不得饱。靠脸吃饭差点饿死，只能拼命积累才华心存现实的理想者漂泊把生命浪费在最美好的事情上Never Mind Never Say Never如果只看3天的朋友圈，可能你会失望吧？Follow my heart 微信上借钱别信努力编码。回复慢请见谅。时间的催促在敲警钟Make a difference悄悄地，留下一撮迷人的香余生很贵，经不起浪费。文艺公号: 豌豆花\\n技术公号: Python猫想自由有急事打电话，但先发短信一下你是谁，否则会陌生人电话夢はきらめき とわに要简单更要快乐!Simple.不要吃太多哦，会被杀掉的加好友请注明：称呼-行业-来意。欢迎互惠交流，不做免费咨询。百无一用是情深13327210833少喝深夜的酒，多喝清晨的粥\\n我演技不错，尤其是假装快乐早成者未必有成，晚达者未必不达。半梦半醒半醉半得半失，知冷知热知足知多知少。成就不凡的路上，一定极度平凡，只有把自己的心固定，才能坚持住我有药🙃🙃🙃如果一顿麻辣烫解决不了的事，就两顿吧～用互联网的智慧联接企业资源、高校学员共同实现远大宏图。。。我爱你，你随意莫听穿林打叶声 何妨吟啸且徐行人间不值得YOU  MAKE  MY  DAY！要么孤独，要么庸俗。静静寻觅生活的美好人生若只如初见，何事秋风悲画扇。知足者常乐越努力，越幸运。多看书，多点内涵少女心侵蚀所有 🍍🍭<span class=\"emoji emoji1f349\"></span><span class=\"emoji emoji1f497\"></span>是烈酒，也是温开水。爱屋及乌～顺利毕业道法自然一直都要酷酷的活得通透而快乐终身学习者、大学教师。欢迎关注我的公众号“玉树芝兰”。人是目的，不是手段从零开始。下意识克制。刻意。滞后满足。精力情绪管理。因果。有趣的灵魂终究会相遇！Fear not for the future,weep not for the past!央视新媒体|科技自媒体|互联网分析专家|道德黑客的都，心静自然凉情贵淡，气贵和，唯淡唯和，乃得其养。奇迹是努力的另一个名字。陪我走过春秋冬夏让每个人都能公平公正的获取优质AI教育服务走自己的路，让别人去说！独立行走Common sense and myself are the same select * from others平凡之路15926802952逆水行舟落子无悔！Stay Hungry Stay Foolish有个性的签名长情不及久伴……生活不易，唯有努力我想每天都吃巧克力蛋糕还不胖电话:13083623014人生就是大闹一场，然后悄然离去！昨天归于天数，明天不必计数，今天心中有数。做一个阳光开朗爱笑的女孩纸非淡泊无以明志 非宁静无以致远何其所幸万事胜意转身不一定软弱，犹豫不一定别无选择！已懂得事物规律，看陌生不再有趣。00茕茕孑立高度自律常有`优质 95成新 MacBook,iPhone 各型号(个人也在用)`欢迎带走等指手待回头做个平凡普通的人！爱自己，是终身浪漫的开始百端拂逆之时，只有逆来顺受之法。越努力 越幸运跨不过去的是苟且，跨过去的是远方。How we correct mistakes that defines us.The Road to Serfdom潜心修炼。\\n做个对社会有用的人。给\\n你\\n小\\n<span class=\"emoji emoji2764\"></span>\\n<span class=\"emoji emoji1f49e\"></span>\\n\\n对\\n我\\n宠\\n爱给自己一点光，要快乐一些各位加我时请备注从哪个平台看到的+名字，谢谢你若盛开，清风自来不接受非学员咨询。先学习业务知识，八大能力，求职宝典愿事后，不再反悔！好奇的探索者三石会创始人；简书红人；山大创业导师…其余百度。。。。。。。。。775🤔有棱有角，散发温柔。清醒时做事；糊涂时读书；怒火时睡觉；独处时思考天道酬勤，上善若水<span class=\"emoji emoji2747\"></span> \\n\\n \\n<span class=\"emoji emoji2747\"></span> \\n\\n\\n<span class=\"emoji emoji2747\"></span>\\n\\n\\n<span class=\"emoji emoji2747\"></span> \\n\\n\\n<span class=\"emoji emoji2747\"></span> \\n\\n\\n\\n<span class=\"emoji emoji1f49e\"></span>Talk is cheap, show me the data!沉稳\\n<span class=\"emoji emoji1f451\"></span>你看那人好像一条狗可不可以教我怎么长胖啊(º﹃º\\xa0)sometimes the truth is not good enough<span class=\"emoji emoji1f353\"></span>尽情可爱<span class=\"emoji emoji1f353\"></span>N=R*×Fp×Ne×F1×Fi×Fc×L平衡好乐观主义和现实创业维艰再不见蚂蚁搬新家逐渐自闭自律给我自由不被嘲笑的梦想，是不值得去实现的。未来对我来说真的很重要强者忍受孤寂，翱翔蓝天；弱者融入喧哗，自甘堕落！你若盛开<span class=\"emoji emoji1f338\"></span><span class=\"emoji emoji1f490\"></span><span class=\"emoji emoji1f337\"></span>🍄，蝴蝶自来🐝🐝🐝经济基础决定上层建筑牢骚太盛防断肠，风物长宜放眼量～(ง •̀_•́)ง愿得一人心，白首不相离你怎么回事？小老弟后来再遇到心动的人也笑着摇摇头说算了。他和他的朋友们从相遇的那天起，我眼中的风景就是你风花雪月，价值连城。\\n师长没有传说来来来，我是快乐的小玩家感谢生命中每一个走过的你实干兴邦你要变得强大，才能保护好自己和你爱的人君且随意滚蛋吧，201818390219162one by one,  step by step. (每天进步一丢丢！<span class=\"emoji emoji1f63c\"></span>)那些曾让你哭的事，总有一天你会笑着说出来……心之所向\\n\\n\\n\\n                  素履以往关注过程，享受生活\\n上半场专注事业，下半场回归家庭品质生活，趣味人生。But you didn\\'t.做事之道，唯敬唯勤，持之以恒。to be a better me。出发总是美丽的，尤其是在一个阳光普照的清晨上路。生活很苦  学会快乐要瘦要有钱A laity𓃟女孩子一定要努力，想要的东西都很贵，想去的地方都很远<span class=\"emoji emoji1f46f\"></span>怦然心动！世上本无事 庸人自扰之人在得意时须沉得住傲气；失意时要忍得住火气会笑的酒窝，会流泪的眼睛陪你长大👪所有的经历都是成长不骄不躁，未来可期～2019请多多指教🍭不要低头 <span class=\"emoji emoji1f451\"></span> 会掉今天的一切就算突然我也不奇怪非常努力，才会毫不费力。。。'"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "str_data = ''\n",
    "for i in range(new_data2.shape[0]):\n",
    "    str_data = str_data + new_data2.iloc[i,4]\n",
    "str_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'啦啦啦如果再见不能红着脸   是否还能红着眼谁的青春不迷茫做自己让以后的自己感谢的事！推荐3个好友减5元，推荐5个好友减10元。新顾客9折，老顾客85折。青春荒唐，不负自己。  ……觉得苦那就吃一颗糖幸福与感恩同行……人意烂漫，只向桃花开二分。心累……夫学者载籍极博，尤考信于六艺。(￣ε(#￣)☆╰╮(ಥ_ಥ)让优秀成为一种习惯！听得见叶儿声声降我觉得人生就是要经历，我需要一段独属于我自己的时光。没有意义，要寻找意义一身诗意千寻瀑，万古人间四月天。最是人间留不住朱颜辞镜花辞树Mind reform!正向，有爱，幸福的传承。静下心来才能看清自己！。理解力争执无论怎样，开心最重要~\\\\(≧▽≦)/~i am a MAN刻意练习，改变变好。天天忙！用扯淡的态度，面对操蛋的人生。海南航空直飞< =\" 2708\"></>️薇薇安千层水果蛋糕< =\" 1f370\"></>，每周二四六甜蜜到货一念放下万般自在.有事打电话，15922604772DO IT, DO IT RIGHT, DO IT RIGHT NOW!hiLIVING FOR YOURSELF新的征程童心不泯我选择，我喜欢！你就是我想要的未来。图书出版——电子工业出版社博文视点啦啦啦make it happenYou make my heart smile.回忆曾经的青葱岁月是现在最大的财富！！！6225684139000063236师者，所以传道！授业，解惑也！大步向前～我爱大自然，其次是艺术坦坦荡荡Life  is  so...溯雪十年孤半影，笔锋三尺半江湖。生如夏花热爱生活！浅醉中年，唯心独醉。人生似茶，苦也似茶，香亦似茶。努力并不是为了感动谁，也并不是做给谁看！简单的生活简单的过铁华姐不思进取浅醉中年，唯心独醉。人生似茶，苦也似茶，香亦似茶。体到、悟道、得到γνῶθι σεαυτόν   μηδὲν ἄγαν专注精准流量，营销思维策划，暴利项目挖掘，欢迎同频朋友交流。 小知不可使谋事，小忠不可使主法。发现自己不求与人相比，但求无愧于自己每日精进唤醒绮梦憎啼鸟，罥入情丝奈网虫。\\n只要心中有喝啥都是酒我们总是习惯了过去，而来不及适应现在。林业相信，确信，坚信。世事无常，珍重眼前只有经受住狂风暴雨的洗礼，才能练就波澜不惊的淡定！！人生常有遗憾，幸好文字能温情温伤。Don\\'t stay whrere you are.彩石滴酒未进人已醉，热泪方流心已碎。淡忘哀愁苦与累，今朝有酒今朝< =\" 1f63a\"></>扬帆，启航！！！不会游泳的程序媛不是好司机所有的为时晚矣都是恰逢其时滴水穿石非一日之寒，君临天下非一日之功。见自己，见天地，见众生为了进步 别怕犯错‼️学习使我快乐🌚我是个杀手，我莫得感情，也莫得钱你好我就好我们真正怕的是我们光明的一面，不是我们阴暗的一面。智者一切求自己，愚者一切求他人如果不能停留下来，那么始终都是过客。未填写有朝一日权倾在手，便杀尽天下负我之人一群狼在草原上可以无敌，一匹狼在月光下依旧可以嚎叫！\\u3000生活，就像骑单车。要保持平衡，就得不断往前走。叽里呱啦咻< =\" 1f431\"></>~杉木、水杉、柳杉、落羽杉Ultimate论，何以为人识人间烟火一个在当地较为“英俊”的人(*¯︶¯*)包子包子包子 体质棒棒我是一只小鸭子，咿呀咿呀游注销自古深情留不住，总是套路得人心。美颜像鸡，不美颜像猪…RuY1今天没约到科三考试的，明早9点前继续约麓谷考场不逼自己一把.不知道自己< =\" 1f236\"></>️多优秀做一只美美的小熊< =\" 1f43b\"></>+86-15574309401越努力越幸运温和从容，岁月静好Yearn soulmate直面恐惧，才能战胜恐惧\\n三年河西三年河东，莫欺少年穷管不了那么多于内，选择一条自己成长的路，荆棘密布，我也得走。微笑面对每一天go go go行业交流永远相信美好的事情即将发生认真对待生活，生活才会认真对你世界这么大，那么美，我要到处看看。不会游泳的程序媛不是好司机Best  wishes for you < =\" 2764\"></>谁不是平凡且伟大着人生充满着期待，梦想连接着未来你不能把这个世界让给你所鄙视的人…一无所有正好，可以放手一博敬畏之心当你一无所有的时候，就真的可以为所欲为了努力才能拥有梦想的实现sometimes,nowhere means now here出来抢劫也要本性the crownless will be kingThere’s such a lot of world to see.用你喜欢的方式探索世界我喜欢一切美的东西和善良的人。< =\" 2764\"></>️听闻遇见，一次就好SinanTang.github.io就是现在。微信公众号:老居杂货铺(Juustore)，欢迎进店收保护费唯一，非之一人生如逆旅 我亦是行人自从得了神经病，整个人可精神多了糖宝，希望你健康快乐的长大挫折总是如期而至，惊喜总是不期而遇大道至简  坚持者寡万物皆有裂痕，那是光照进来的地方宽于慈善，不忤于物。Msjjsjse年轻就该拼命！否则就是浪费光阴！淳德全道，和于阴阳，调于四时，去世离俗，积精全神……Godlovezt~往后的余生，我只要你。18874286389抓紧时间追赶在你之上的那些人！我能否变成淤泥，再一次沾染你见天地，见众生，见自己，足以见世面富在术数，不在劳身；利在势居，不在力耕。「正青春，去探索」fasker＆健哥的迷妹！！与城市数据团一起学习数据分析～(\\xa0*・ω・)✄为精彩生活而活着 -- L XLYouth is not a time of life; it is a state of mind.好好生活付费知识的搬运工sunset lover虽有多闻，若不修行，与不闻等。如人说食，终不得饱。靠脸吃饭差点饿死，只能拼命积累才华心存现实的理想者漂泊把生命浪费在最美好的事情上Never Mind Never Say Never如果只看3天的朋友圈，可能你会失望吧？Follow my heart 微信上借钱别信努力编码。回复慢请见谅。时间的催促在敲警钟Make a difference悄悄地，留下一撮迷人的香余生很贵，经不起浪费。文艺公号: 豌豆花\\n技术公号: Python猫想自由有急事打电话，但先发短信一下你是谁，否则会陌生人电话夢はきらめき とわに要简单更要快乐!Simple.不要吃太多哦，会被杀掉的加好友请注明：称呼-行业-来意。欢迎互惠交流，不做免费咨询。百无一用是情深13327210833少喝深夜的酒，多喝清晨的粥\\n我演技不错，尤其是假装快乐早成者未必有成，晚达者未必不达。半梦半醒半醉半得半失，知冷知热知足知多知少。成就不凡的路上，一定极度平凡，只有把自己的心固定，才能坚持住我有药🙃🙃🙃如果一顿麻辣烫解决不了的事，就两顿吧～用互联网的智慧联接企业资源、高校学员共同实现远大宏图。。。我爱你，你随意莫听穿林打叶声 何妨吟啸且徐行人间不值得YOU  MAKE  MY  DAY！要么孤独，要么庸俗。静静寻觅生活的美好人生若只如初见，何事秋风悲画扇。知足者常乐越努力，越幸运。多看书，多点内涵少女心侵蚀所有 🍍🍭<span =\"emoji emoji1f349\"></span><span =\"emoji emoji1f497\"></span>是烈酒，也是温开水。爱屋及乌～顺利毕业道法自然一直都要酷酷的活得通透而快乐终身学习者、大学教师。欢迎关注我的公众号“玉树芝兰”。人是目的，不是手段从零开始。下意识克制。刻意。滞后满足。精力情绪管理。因果。有趣的灵魂终究会相遇！Fear not for the future,weep not for the past!央视新媒体|科技自媒体|互联网分析专家|道德黑客的都，心静自然凉情贵淡，气贵和，唯淡唯和，乃得其养。奇迹是努力的另一个名字。陪我走过春秋冬夏让每个人都能公平公正的获取优质AI教育服务走自己的路，让别人去说！独立行走Common sense and myself are the same select * from others平凡之路15926802952逆水行舟落子无悔！Stay Hungry Stay Foolish有个性的签名长情不及久伴……生活不易，唯有努力我想每天都吃巧克力蛋糕还不胖电话:13083623014人生就是大闹一场，然后悄然离去！昨天归于天数，明天不必计数，今天心中有数。做一个阳光开朗爱笑的女孩纸非淡泊无以明志 非宁静无以致远何其所幸万事胜意转身不一定软弱，犹豫不一定别无选择！已懂得事物规律，看陌生不再有趣。00茕茕孑立高度自律常有`优质 95成新 MacBook,iPhone 各型号(个人也在用)`欢迎带走等指手待回头做个平凡普通的人！爱自己，是终身浪漫的开始百端拂逆之时，只有逆来顺受之法。越努力 越幸运跨不过去的是苟且，跨过去的是远方。How we correct mistakes that defines us.The Road to Serfdom潜心修炼。\\n做个对社会有用的人。给\\n你\\n小\\n<span =\"emoji emoji2764\"></span>\\n<span =\"emoji emoji1f49e\"></span>\\n\\n对\\n我\\n宠\\n爱给自己一点光，要快乐一些各位加我时请备注从哪个平台看到的+名字，谢谢你若盛开，清风自来不接受非学员咨询。先学习业务知识，八大能力，求职宝典愿事后，不再反悔！好奇的探索者三石会创始人；简书红人；山大创业导师…其余百度。。。。。。。。。775🤔有棱有角，散发温柔。清醒时做事；糊涂时读书；怒火时睡觉；独处时思考天道酬勤，上善若水<span =\"emoji emoji2747\"></span> \\n\\n \\n<span =\"emoji emoji2747\"></span> \\n\\n\\n<span =\"emoji emoji2747\"></span>\\n\\n\\n<span =\"emoji emoji2747\"></span> \\n\\n\\n<span class=\"emoji emoji2747\"></span> \\n\\n\\n\\n<span class=\"emoji emoji1f49e\"></span>Talk is cheap, show me the data!沉稳\\n<span class=\"emoji emoji1f451\"></span>你看那人好像一条狗可不可以教我怎么长胖啊(º﹃º\\xa0)sometimes the truth is not good enough<span class=\"emoji emoji1f353\"></span>尽情可爱<span class=\"emoji emoji1f353\"></span>N=R*×Fp×Ne×F1×Fi×Fc×L平衡好乐观主义和现实创业维艰再不见蚂蚁搬新家逐渐自闭自律给我自由不被嘲笑的梦想，是不值得去实现的。未来对我来说真的很重要强者忍受孤寂，翱翔蓝天；弱者融入喧哗，自甘堕落！你若盛开<span class=\"emoji emoji1f338\"></span><span class=\"emoji emoji1f490\"></span><span class=\"emoji emoji1f337\"></span>🍄，蝴蝶自来🐝🐝🐝经济基础决定上层建筑牢骚太盛防断肠，风物长宜放眼量～(ง •̀_•́)ง愿得一人心，白首不相离你怎么回事？小老弟后来再遇到心动的人也笑着摇摇头说算了。他和他的朋友们从相遇的那天起，我眼中的风景就是你风花雪月，价值连城。\\n师长没有传说来来来，我是快乐的小玩家感谢生命中每一个走过的你实干兴邦你要变得强大，才能保护好自己和你爱的人君且随意滚蛋吧，201818390219162one by one,  step by step. (每天进步一丢丢！<span class=\"emoji emoji1f63c\"></span>)那些曾让你哭的事，总有一天你会笑着说出来……心之所向\\n\\n\\n\\n                  素履以往关注过程，享受生活\\n上半场专注事业，下半场回归家庭品质生活，趣味人生。But you didn\\'t.做事之道，唯敬唯勤，持之以恒。to be a better me。出发总是美丽的，尤其是在一个阳光普照的清晨上路。生活很苦  学会快乐要瘦要有钱A laity𓃟女孩子一定要努力，想要的东西都很贵，想去的地方都很远<span class=\"emoji emoji1f46f\"></span>怦然心动！世上本无事 庸人自扰之人在得意时须沉得住傲气；失意时要忍得住火气会笑的酒窝，会流泪的眼睛陪你长大👪所有的经历都是成长不骄不躁，未来可期～2019请多多指教🍭不要低头 <span class=\"emoji emoji1f451\"></span> 会掉今天的一切就算突然我也不奇怪非常努力，才会毫不费力。。。'"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import re\n",
    "str_data = re.sub('span', '',str_data,re.S)\n",
    "str_data = re.sub('class', '',str_data,re.S)\n",
    "str_data = re.sub('emoji', '',str_data,re.S)\n",
    "str_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "Building prefix dict from the default dictionary ...\n",
      "DEBUG:jieba:Building prefix dict from the default dictionary ...\n",
      "Loading model from cache C:\\Users\\luopan\\AppData\\Local\\Temp\\jieba.cache\n",
      "DEBUG:jieba:Loading model from cache C:\\Users\\luopan\\AppData\\Local\\Temp\\jieba.cache\n",
      "Loading model cost 0.605 seconds.\n",
      "DEBUG:jieba:Loading model cost 0.605 seconds.\n",
      "Prefix dict has been built succesfully.\n",
      "DEBUG:jieba:Prefix dict has been built succesfully.\n"
     ]
    }
   ],
   "source": [
    "import jieba.analyse\n",
    "tags = jieba.analyse.extract_tags(str_data, topK=50, withWeight=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "span\t347\n",
      "emoji\t173\n",
      "class\t100\n",
      "人生\t52\n",
      "努力\t46\n",
      "自己\t45\n",
      "emoji2747\t45\n",
      "快乐\t45\n",
      "生活\t38\n",
      "go\t27\n",
      "Never\t27\n",
      "平凡\t27\n",
      "欢迎\t26\n",
      "才能\t24\n",
      "总是\t21\n",
      "包子\t21\n",
      "不是\t20\n",
      "好友\t19\n",
      "美颜\t19\n",
      "幸运\t18\n",
      "Mind\t18\n",
      "DO\t18\n",
      "RIGHT\t18\n",
      "make\t18\n",
      "my\t18\n",
      "heart\t18\n",
      "浅醉\t18\n",
      "独醉\t18\n",
      "似茶\t18\n",
      "香亦似\t18\n",
      "2764\t18\n",
      "sometimes\t18\n",
      "微信\t18\n",
      "公号\t18\n",
      "Stay\t18\n",
      "emoji1f49e\t18\n",
      "me\t18\n",
      "emoji1f451\t18\n",
      "emoji1f353\t18\n",
      "step\t18\n",
      "青春\t18\n",
      "浪费\t17\n",
      "梦想\t17\n",
      "美好\t17\n",
      "人间\t16\n",
      "咿呀\t16\n",
      "就是\t16\n",
      "唯心\t16\n",
      "交流\t15\n",
      "余生\t15\n"
     ]
    }
   ],
   "source": [
    "label = []\n",
    "attr = []\n",
    "for item in tags:\n",
    "    print(item[0]+'\\t'+str(int(item[1]*1000)))\n",
    "    label.append(item[0])\n",
    "    attr.append(int(item[1]*1000))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<script>\n",
       "    require.config({\n",
       "        paths: {\n",
       "            'echarts': '/nbextensions/echarts/echarts.min', 'wordcloud': '/nbextensions/echarts/echarts-wordcloud.min'\n",
       "        }\n",
       "    });\n",
       "</script>\n",
       "    <div id=\"b371b2c2ea124dd49a17aa94d9056b8c\" style=\"width:800px;height:620px;\"></div>\n",
       "\n",
       "\n",
       "<script>\n",
       "    require(['echarts', 'wordcloud'], function(echarts) {\n",
       "        \n",
       "var myChart_b371b2c2ea124dd49a17aa94d9056b8c = echarts.init(document.getElementById('b371b2c2ea124dd49a17aa94d9056b8c'), 'light', {renderer: 'canvas'});\n",
       "\n",
       "var option_b371b2c2ea124dd49a17aa94d9056b8c = {\n",
       "    \"title\": [\n",
       "        {\n",
       "            \"left\": \"auto\",\n",
       "            \"top\": \"auto\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 18\n",
       "            },\n",
       "            \"subtextStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"toolbox\": {\n",
       "        \"show\": true,\n",
       "        \"orient\": \"vertical\",\n",
       "        \"left\": \"95%\",\n",
       "        \"top\": \"center\",\n",
       "        \"feature\": {\n",
       "            \"saveAsImage\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"save as image\"\n",
       "            },\n",
       "            \"restore\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"restore\"\n",
       "            },\n",
       "            \"dataView\": {\n",
       "                \"show\": true,\n",
       "                \"title\": \"data view\"\n",
       "            }\n",
       "        }\n",
       "    },\n",
       "    \"series_id\": 8318071,\n",
       "    \"tooltip\": {\n",
       "        \"trigger\": \"item\",\n",
       "        \"triggerOn\": \"mousemove|click\",\n",
       "        \"axisPointer\": {\n",
       "            \"type\": \"line\"\n",
       "        },\n",
       "        \"textStyle\": {\n",
       "            \"fontSize\": 14\n",
       "        },\n",
       "        \"backgroundColor\": \"rgba(50,50,50,0.7)\",\n",
       "        \"borderColor\": \"#333\",\n",
       "        \"borderWidth\": 0\n",
       "    },\n",
       "    \"series\": [\n",
       "        {\n",
       "            \"type\": \"wordCloud\",\n",
       "            \"shape\": \"circle\",\n",
       "            \"rotationRange\": [\n",
       "                -90,\n",
       "                90\n",
       "            ],\n",
       "            \"rotationStep\": 45,\n",
       "            \"girdSize\": 20,\n",
       "            \"sizeRange\": [\n",
       "                20,\n",
       "                100\n",
       "            ],\n",
       "            \"data\": [\n",
       "                {\n",
       "                    \"name\": \"\\u52aa\\u529b\",\n",
       "                    \"value\": 46,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(53,19,156)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u81ea\\u5df1\",\n",
       "                    \"value\": 45,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(23,117,96)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"emoji2747\",\n",
       "                    \"value\": 45,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(63,3,50)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5feb\\u4e50\",\n",
       "                    \"value\": 45,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(152,7,37)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u751f\\u6d3b\",\n",
       "                    \"value\": 38,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(80,68,152)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"go\",\n",
       "                    \"value\": 27,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(87,39,39)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"Never\",\n",
       "                    \"value\": 27,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(21,71,67)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e73\\u51e1\",\n",
       "                    \"value\": 27,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(57,59,51)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u6b22\\u8fce\",\n",
       "                    \"value\": 26,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(96,143,51)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u624d\\u80fd\",\n",
       "                    \"value\": 24,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(144,93,59)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u603b\\u662f\",\n",
       "                    \"value\": 21,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(19,28,96)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5305\\u5b50\",\n",
       "                    \"value\": 21,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(139,157,118)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u4e0d\\u662f\",\n",
       "                    \"value\": 20,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(6,50,88)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u597d\\u53cb\",\n",
       "                    \"value\": 19,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(132,117,37)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u7f8e\\u989c\",\n",
       "                    \"value\": 19,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(152,87,160)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5e78\\u8fd0\",\n",
       "                    \"value\": 18,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(122,69,89)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"Mind\",\n",
       "                    \"value\": 18,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(4,37,143)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"DO\",\n",
       "                    \"value\": 18,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(108,18,43)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"RIGHT\",\n",
       "                    \"value\": 18,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(160,61,130)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"make\",\n",
       "                    \"value\": 18,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(137,40,82)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"my\",\n",
       "                    \"value\": 18,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(45,19,53)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"heart\",\n",
       "                    \"value\": 18,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(156,81,97)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u6d45\\u9189\",\n",
       "                    \"value\": 18,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(50,128,40)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u72ec\\u9189\",\n",
       "                    \"value\": 18,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(4,140,154)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u4f3c\\u8336\",\n",
       "                    \"value\": 18,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(99,128,82)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u9999\\u4ea6\\u4f3c\",\n",
       "                    \"value\": 18,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(40,141,65)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"2764\",\n",
       "                    \"value\": 18,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(103,65,63)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"sometimes\",\n",
       "                    \"value\": 18,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(76,82,26)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5fae\\u4fe1\",\n",
       "                    \"value\": 18,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(38,28,117)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u516c\\u53f7\",\n",
       "                    \"value\": 18,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(123,139,22)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"Stay\",\n",
       "                    \"value\": 18,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(22,101,59)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"emoji1f49e\",\n",
       "                    \"value\": 18,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(144,76,148)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"me\",\n",
       "                    \"value\": 18,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(9,96,160)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"emoji1f451\",\n",
       "                    \"value\": 18,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(159,103,120)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"emoji1f353\",\n",
       "                    \"value\": 18,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(102,94,127)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"step\",\n",
       "                    \"value\": 18,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(87,61,154)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u9752\\u6625\",\n",
       "                    \"value\": 18,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(73,73,102)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u6d6a\\u8d39\",\n",
       "                    \"value\": 17,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(133,102,151)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u68a6\\u60f3\",\n",
       "                    \"value\": 17,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(104,96,153)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u7f8e\\u597d\",\n",
       "                    \"value\": 17,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(92,83,45)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u4eba\\u95f4\",\n",
       "                    \"value\": 16,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(63,64,56)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u54bf\\u5440\",\n",
       "                    \"value\": 16,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(96,115,138)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u5c31\\u662f\",\n",
       "                    \"value\": 16,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(114,64,126)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u552f\\u5fc3\",\n",
       "                    \"value\": 16,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(37,115,153)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u4ea4\\u6d41\",\n",
       "                    \"value\": 15,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(15,93,117)\"\n",
       "                        }\n",
       "                    }\n",
       "                },\n",
       "                {\n",
       "                    \"name\": \"\\u4f59\\u751f\",\n",
       "                    \"value\": 15,\n",
       "                    \"textStyle\": {\n",
       "                        \"normal\": {\n",
       "                            \"color\": \"rgb(65,159,127)\"\n",
       "                        }\n",
       "                    }\n",
       "                }\n",
       "            ]\n",
       "        }\n",
       "    ],\n",
       "    \"legend\": [\n",
       "        {\n",
       "            \"data\": [],\n",
       "            \"selectedMode\": \"multiple\",\n",
       "            \"show\": true,\n",
       "            \"left\": \"center\",\n",
       "            \"top\": \"top\",\n",
       "            \"orient\": \"horizontal\",\n",
       "            \"textStyle\": {\n",
       "                \"fontSize\": 12\n",
       "            }\n",
       "        }\n",
       "    ],\n",
       "    \"animation\": true,\n",
       "    \"color\": [\n",
       "        \"#c23531\",\n",
       "        \"#2f4554\",\n",
       "        \"#61a0a8\",\n",
       "        \"#d48265\",\n",
       "        \"#749f83\",\n",
       "        \"#ca8622\",\n",
       "        \"#bda29a\",\n",
       "        \"#6e7074\",\n",
       "        \"#546570\",\n",
       "        \"#c4ccd3\",\n",
       "        \"#f05b72\",\n",
       "        \"#ef5b9c\",\n",
       "        \"#f47920\",\n",
       "        \"#905a3d\",\n",
       "        \"#fab27b\",\n",
       "        \"#2a5caa\",\n",
       "        \"#444693\",\n",
       "        \"#726930\",\n",
       "        \"#b2d235\",\n",
       "        \"#6d8346\",\n",
       "        \"#ac6767\",\n",
       "        \"#1d953f\",\n",
       "        \"#6950a1\",\n",
       "        \"#918597\",\n",
       "        \"#f6f5ec\"\n",
       "    ]\n",
       "};\n",
       "myChart_b371b2c2ea124dd49a17aa94d9056b8c.setOption(option_b371b2c2ea124dd49a17aa94d9056b8c);\n",
       "\n",
       "    });\n",
       "</script>\n"
      ],
      "text/plain": [
       "<pyecharts.charts.wordcloud.WordCloud at 0x202c22f0b00>"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "LOG OUT!\n",
      "INFO:itchat:LOG OUT!\n"
     ]
    }
   ],
   "source": [
    "from pyecharts import WordCloud\n",
    "\n",
    "wordcloud = WordCloud(width=800, height=620)\n",
    "wordcloud.add(\"\", label[4:], attr[4:], word_size_range=[20, 100])\n",
    "wordcloud"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
